Problem Note 41312: An aggregation job fails if you delete target tables in SAS® IT Resource Management that share join columns within the same aggregation transformation
 |  |  |  |
In SAS IT Resource Management, when you delete a target table of an aggregation transformation that provides join columns to another aggregation table, then the aggregation job fails. An error appears that is similar to the following example:
ERROR: File WORK.NULL.DATA does not exist.
ERROR: SQL View WORK._JOIN_A5VJFVZ5_B700009Z could not
be processed because at least one of the data
sets, or views, referenced directly (or indirectly)
by it could not be located, or opened successfully.
If you have not saved the job, it is possible to reinstate the target tables. To reinstate the target tables, select Edit ► Undo.
However, once the job is saved it is not possible to restore this mapping by re-associating the source table.
Note: If you then attempt to perform this association, the job cannot be deployed, and errors occur that pertain to column mappings.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS IT Resource Management-Server | Windows Vista | 3.2 | 9.2 TS2M3 | ||
| Windows 7 Ultimate x64 | 3.2 | 3.5 | 9.2 TS2M3 | 9.4 TS1M2 | ||
| Windows 7 Ultimate 32 bit | 3.2 | 3.5 | 9.2 TS2M3 | 9.4 TS1M2 | ||
| Windows 7 Professional x64 | 3.2 | 3.5 | 9.2 TS2M3 | 9.4 TS1M2 | ||
| Windows 7 Professional 32 bit | 3.2 | 3.5 | 9.2 TS2M3 | 9.4 TS1M2 | ||
| Windows 7 Home Premium x64 | 3.2 | 3.5 | 9.2 TS2M3 | 9.4 TS1M2 | ||
| Windows 7 Home Premium 32 bit | 3.2 | 3.5 | 9.2 TS2M3 | 9.4 TS1M2 | ||
| Windows 7 Enterprise x64 | 3.2 | 3.5 | 9.2 TS2M3 | 9.4 TS1M2 | ||
| Windows 7 Enterprise 32 bit | 3.2 | 3.5 | 9.2 TS2M3 | 9.4 TS1M2 | ||
| Microsoft Windows XP Professional | 3.2 | 9.2 TS2M3 | ||||
| Microsoft Windows Server 2008 for x64 | 3.2 | 3.5 | 9.2 TS2M3 | 9.4 TS1M2 | ||
| Microsoft Windows Server 2008 | 3.2 | 3.5 | 9.2 TS2M3 | 9.4 TS1M2 | ||
| Microsoft Windows Server 2003 for x64 | 3.2 | 9.2 TS2M3 | ||||
| Microsoft Windows Server 2003 Standard Edition | 3.2 | 9.2 TS2M3 | ||||
| Microsoft Windows Server 2003 Enterprise Edition | 3.2 | 9.2 TS2M3 | ||||
| Microsoft Windows Server 2003 Datacenter Edition | 3.2 | 9.2 TS2M3 | ||||
| Microsoft® Windows® for x64 | 3.2 | 3.5 | 9.2 TS2M3 | 9.4 TS1M2 | ||
| Microsoft Windows XP 64-bit Edition | 3.2 | 9.2 TS2M3 | ||||
| Microsoft Windows Server 2003 Enterprise 64-bit Edition | 3.2 | 9.2 TS2M3 | ||||
| Microsoft Windows Server 2003 Datacenter 64-bit Edition | 3.2 | 9.2 TS2M3 | ||||
| Microsoft® Windows® for 64-Bit Itanium-based Systems | 3.2 | 9.2 TS2M3 | ||||
| z/OS | 3.2 | 3.5 | 9.2 TS2M3 | 9.4 TS1M2 | ||
| Windows Vista for x64 | 3.2 | 9.2 TS2M3 | ||||
| 64-bit Enabled AIX | 3.2 | 3.5 | 9.2 TS2M3 | 9.4 TS1M2 | ||
| 64-bit Enabled HP-UX | 3.2 | 3.5 | 9.2 TS2M3 | 9.4 TS1M2 | ||
| 64-bit Enabled Solaris | 3.2 | 3.5 | 9.2 TS2M3 | 9.4 TS1M2 | ||
| HP-UX IPF | 3.2 | 3.5 | 9.2 TS2M3 | 9.4 TS1M2 | ||
| Linux | 3.2 | 3.5 | 9.2 TS2M3 | 9.4 TS1M2 | ||
| Linux for x64 | 3.2 | 3.5 | 9.2 TS2M3 | 9.4 TS1M2 | ||
| Solaris for x64 | 3.2 | 3.5 | 9.2 TS2M3 | 9.4 TS1M2 | ||
An aggregation job fails if you delete target tables in SAS® IT Resource Management that share join columns within the same aggregation transformation.
| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2011-04-28 11:14:17 |
| Date Created: | 2010-10-19 10:52:29 |